import sqlite3

conn = sqlite3.connect('db/data.db')
c = conn.cursor()


c.execute('''CREATE TABLE ITEMCOPYWRITING
       (TITLE        TEXT        NOT NULL,
       FEATURE       TEXT        NULL,
       OCCASION      TEXT        NULL);''')


c.execute("INSERT INTO ITEMCOPYWRITING (TITLE,FEATURE,OCCASION) \
      VALUES ('Women Cuff V Neck Polka Dot Polka Dot Belt Dress', 'Polka Dot, Belt, Long Sleeve, V neck, Surplice', 'Casual/Party/Work/Holiday Style/Thanksgiving/Halloween/Christmas')")

c.execute("INSERT INTO ITEMCOPYWRITING (TITLE,FEATURE,OCCASION) \
      VALUES ('Women Bracelet V Neck Solid Color Shirt Dress Button Lapel Mini Dress', \
      'Shirt Dress, Button, Lapel Mini, Long Sleeve, v neck, Jacket Dress', 'Casual/Party/Work/Holiday Style/Thanksgiving/Halloween/Christmas')")

c.execute("INSERT INTO ITEMCOPYWRITING (TITLE,FEATURE,OCCASION) \
      VALUES ('Women Balloon Turtleneck Floral Print Belt Floral Print Babydoll Dress', \
      'Belt, Floral Print, Babydoll, Long Sleeve, turtleneck, Babydoll', 'Casual/Party/Work/Holiday Style/Thanksgiving/Halloween/Christmas')")

c.execute("INSERT INTO ITEMCOPYWRITING (TITLE,FEATURE,OCCASION) \
      VALUES ('Women Balloon Crew Neck Floral Print Floral Print Belt Dress', \
      'Floral Print, Belt, Long Sleeve, crew neck, Babydoll', 'Casual/Party/Work/Holiday Style/Thanksgiving/Halloween/Christmas')")



print ("数据库初始化成功")
conn.commit()
conn.close()